The Audubon Aquarium of the Americas in New Orleans, LA, USA, is located on the harbor front and very close to the French Quarter. Both times I've visited NOLA, I've stayed on Frenchman Street because it's centrally located and easy to walk to many attractions. Both times I visited the Aquarium. (You can read about my last visit here). There's a trolley that goes along the waterfront starting at Frenchman Street and easily drops you off right behind the aquarium.
This aquarium isn't huge, but it has some really great exhibits. I particularly like the Carribbean tunnel where the tank is on all sides and above of the viewer and the Mississippi River section that has bayou birds, gators, and fishes.
All the usual creatures are there, including penguins, eels, frogs and otters. There's a imax theater and cafeteria, although I've never visited those.
My absolute favorite part is a little hard to find as it's not on the main path and one has to walk through the cafeteria to get to it. Parakeet Pointe is a little arboretum and bird cage that extends out of the main building into the open air and over the entrance of the aquarium. It's really fun to be around hundreds of flying, speaking, budgies of all bright colors. On our last trip we even saw a small hawk spying on them from outside the cage. He was trying hard to figure out how to make one of these parakeets, that were outside but still behind bars, his lunch.
The Audubon Aquarium of Americas also has the hallmark of all good aquariums... Jellies!!
I highly recommend this aquarium but also suggest you also visit the Audubon Insectarium which is just a few blocks away. If you like bugs, it will blow your mind!
Next time we visit I also hope to visit the Audubon Zoo!