There are multiple lakes in the area that can be enjoyed from a canoe or kayak. Paddling lake water is certainly different from the flowing water of rivers, but shores and islands can be explored and provide great picnic and camping sites. Still-water paddling can be an awesome experience for a solo-paddler, a group, or a family. These lakes are certainly within local access:

Lake Guntersville

Tims Ford Smith

Lake Lake Wheeler