In Nashville, TN there is a resturaunt called "The Aquarium". It is in the Opry Mills Mall.
When you are walking to the dining area you walk under an arched tank that is around 26,000 gallons and in the middle of the dining area is a 200,000 gal. tank with hammerhead sharks, huge puffers, etc.