Weather will be better that Scot!! Where to stay and what to do all depends on what you like to do (other than night life). How long do you plan to stay and just in Houston or do you plan to go elsewhere in Texas?
Lots of things to do in Houston - it is vast and spread out. You will need a car as public transport is pretty bad.
The big tourist item is NASA - but the museums, parks, theater (theatre), bars, restaurants (night life) - all are good. If into sports - maybe a sporting event - maybe a pre-season baseball game (not quite - but like cricket).
As far as where to stay - without knowing all the details to me the default is the Galleria area. Once you give more details - the Houston group will give you all the answers.
P.S. - Will even lie for a bottle of Oban - maybe even kill for MCcallan (sp)? 25!! LOL