Anywhere smoking is allowed in Atlanta, pipes will be welcomed as well. Granted, you'll be met with the usual curious, but not unfriendly, looks.
You'll see the occassional pipe smoker in a lot of the pubs in East Atlanta Village (granted, that's usually me), as well as Little 5 points (actually, that's usually me too).