Chattahoochee River - Ah, way down yonder by the Chattahoochee… this stretch of river always has water (as of now!) and was formerly the site of the (in)famous shoot-the-hooch summer event.
No particularly great play sites — even at higher water — though the play isn’t any worse at low water: the devil’s racecourse channel opens up at low water with decent squirt and ender spots.