Been living in Houston for 6 months now. The bars are all over Houston but are kind of clustered. Midtown is your young professional crowd and Washington St is another good place for bars. Galleria has some as well. I would recommend staying downtown at the Hyatt or similar and just catching a cab to the bars a 10 minute ride away. You can then take the light rail from downtown to the stadium and back. If you want to stay around the galleria, that's not bad either. I live in midtown just because I like the crowd and atmosphere. There are some bars in downtown too but more pregame style. PM me if you have any specific questions and I'll do what I can to help.