In the Rome area, there's the Coosa/Etowah River, and I'm a big fan of Dry Creek that's close by. It's past the season, but early spring Stripers make a run through there...and it's a sight to behold. There's a honey hole among those three which I'll keep to myself
Little River Canyon just across the GA line in Alabama is another favorite spot of mine.
Coosawattee River leading up to Carter's Dam at Carter's Lake. Carter's Lake overall, but also the creeks that branch off the Lake. Carter's lake is pretty well known for some great Striper fishing.
If you have the time, I'd highly recommend Bay/Ocean fishing in a Kayak. Some of the most fun I've ever had was saltwater fishing in a Kayak...especially a good stable kayak that will allow you to stand. I have a pedal drive kayak which is kinda cheating if you're kayak purist, but dang it if my arms like it more than paddling!