Downtown Aquarium, Houston

While not a proper city- or state-run aquarium (Houston doesn't have one such), this place has quite a few things to offer. You can play with stingrays, ride a train into a shark tank, see white tigers, check out some pretty cool-looking fish and corals, and have a fun time. It's a tourist attraction, equipped with a full-service restaurant, an upscale bar, a fully equipped ballroom, a gift shop, a fountain/splash pad area, amusement rides, plus a variety of games with prizes to win.

The view of the fish tanks while dining is among the best parts of the attraction. It seems like every table has a nice view of a nice tank with really big fish and other sea life. You're not just paying for the food, but for the overall experience, so it's going to cost some extra. There is also a small patio outside from the bar area if you prefer outdoor seating.

Tip:
It's a better value deal to get the all-day wristbands if you want to make the most of your experience.