I don't know anything about lakes or ponds around the area you mentioned.
I do know about taking grandsons and granddaughters fishing. Like the others mentioned, rig him up so he can catch something to keep him interested. Be sure to take snacks and drinks.
The first time I took my oldest grandson fishing we went to a pay to catch and keep trout pond. His only fish was a 3lb rainbow that costed me $15.00. The whole trip was priceless. Have fun and enjoy your time with him. They grow up so fast. Jim
I'm either going to, coming from or thinking about fishing. Jim