Even though my address says Glenmoore PA, I lived in Alpharetta for almost 20 years. The best/closest place to go is the Chattahoochee River, it's the tailwater for Lake Lanier. Lots of big trout, but you will need a float tube to fish it (lots of drop offs). I don't know how the drought has affected the river, but I know that they have gotten some rain this winter. I was just there last week for a wild boar hunt and of course it rained for 2 days straight. I think the Alpharetta area got over 2", so that should help bring the lake levels up.