Anyone live in Atlanta?

We're planning our yearly vacation and we thought about going to Atlanta and visit the Zoo, Botanical Garden and Aquarium. Anyone live there and been to any of these places? Is it worth it? We would need a hotel near those places also, if anyone knows a good hotel near that would be helpful also. TIA.