Hey, and welcome to the site.

I regularly fish the South Harpeth, the fish are small but fun to catch. There are spots all over to access it. There are several boat docks out on the Cumberland along the way out towards Ashland City, try River road. And they are all pretty much on the creeks that flow into the Cumberland, so you could even canoe or jon boat them easily.