Athens has two sirens that I know of, both are Federal SD-10 sirens. One is located next to the water tower in the downtown area, and the other is at the ballpark on the southwest side of town. Here's a map showing the locations of their two sirens:
http://goo.gl/maps/qsNcM