I, for one, hope you are treated the same way I was treated in Chicago as an Astros fan.
If so, you'll have a great trip. I only caught mess from one guy, and the rest of the fans and town were great.
The past two trips I've made to Houston from Arkansas I went on Priceline and ended up at the Hyatt both times for 50 bucks a night. Super rooms for 50ish a night. Walking distance from the park. I know there is a bar or two around the stadium. Can't remember which one we went to but it was three letters.