In my former life I wanted to be an airline pilot. But like you, I realized it's not as glamorous as most think.
I have CFI, CFII, MEI, and IGI certificates and give freelance instruction when I'm not earning a living at my real job. I've done nearly all of my training and flying out of Houston (primarily Hooks). Hooks is a great "little" airport with lots of options. United Flight Systems is the main flight school there:
http://unitedflight.com/I have dealt with United a lot and find it to be a good school with many rental options. They have everything from 150's to twins and even have the new Cessna 162 (The Cessna light sport). I generally rent the C182 ($210/hr) but they have a number of 172's that rent around $150/hr.
As Aero mentioned, flight clubs can be a good option. However, I have yet to find one in Houston that I thought was a better deal then just renting at a FBO.
EDIT: I just realized Hi-Tech Aviation went out of business.
[This message has been edited by 13wins (edited 2/22/2012 3:18p).]