A place i've had great luck out here and with my little bro before was at the edge of gallatin and hendersonville
I'll edit this post with a pic.
On the left of the parking lot when you pull in beside the tree line is great for smaller fish for kids. Not tiny ones but nothing that will break their pole or line.
My little brother love sit out here due to he catches quite a few.
Also good for some catfishing too