Well,I recently visited Adventure Aquarium in New Jersey and as nice as that was this blows them away....I will have to visit this aquarium some day.
its right in the middle of downtown Atlanta at pemberton place. Thats right next to coca-cola world and the CNN center. Ticket prices change day to day i think but range is probably between 30-40 dollars. You can get a city pass atlanta which lets you visit the CNN center, Coke world, Aquarium, Zoo, and a few other places for 70 bucks