We had our wedding reception at the Brownfield House in Opelika. At the time (about three years ago), it was managed by the Opelika Historical Society. I don't know how big your wedding will be, but I think the Brownfield House holds about 100-150 people? Check with them first though and don't take my word for it! :) The address to the house is 611 N 8th St, Opelika, AL. (If you're interested, I can send you some better pictures of the house from my wedding).
The Crenshaw Guest House is much smaller (http://www.crenshawguesthouse.com/index.html), but also very nice and does weddings and receptions I believe. My family stayed there the weekend of my wedding and they really made up feel at home! :)
Also, I just saw this site that Auburn-Opelika Tourism has updated. http://www.aotourism.com/Weddings/Default.aspx?Qnty=-1
I lived in Auburn from 7 years, so I've had some sort of contact (whether personally, or by going to other peoples' weddings/events over the years) with several of the places on this list. If you have any questions about any of the places you see on there, let me know and I'll tell you what I know about them!! :)
Congratulations on your upcoming wedding!! :)
Click on each tool to see a sample.