There are a number of good hotels near the Houston Airport. I have had success finding good rates at the Doubletree, Comfort Suites and the Sheraton and all were fine for a 1-night pre-cruise. Depends on what kind of amenities you are looking for.
As for transfers to and from the terminal, check out www.cruiseshipshuttle.com
. They are very reliable and can transfer groups of all sizes.