I recommend south of Atlanta, simply because that way you don't have to drive through Atlanta to get to the best, or at least most accessible, hunting areas. (That said, there is some mighty fine hunting in the northern part of the state as well.)
I do not recommend Macon per se, but it is centrally located and close enough to Atlanta, the coast and the more southerly areas of the state that traveling to any of them is not too bad. But many of the smaller towns in Middle Ga. are nice communities. Biggie Hoffman and I both live in Gray, about 20 miles from Macon, and despite that fact that they let us both live here, its still a good place to be. There is a lot of public land to hunt on, and with a little study, you can find good places that are not overrun by other hunters. Deer and turkey are plentiful. Also, you can probably locate some really nice hunt clubs also. I saw Madison mentioned in a previous post and agree that it is a really nice town as well.
We have gnats, mosquitos, and ticks in great profusion. Also snakes. So get good snake boots, and learn about Permanone! Lastly,unless you have previously spent time in this part of the country, you will run into heat and humidity that will really surprise you with its intensity. The heat by itself is not so bad - nothing like our Western friends have, but combined with the humidity,it is tough to handle. Early archey season is hot!
Being a native Georgian I may be a little prejudiced, but I think you will find good hunting and good friends aplenty whatever area of the state you choose.
You need to check out Traditional Bowhunters of Georgia and even Traditional Bowhunters of Florida. Lots of really good folks. Y'all Come on down, and and we will have you talking Southern in less than a year.