Hey Melissa, you could take him up to Gaston, there is a place we stay at every year called Stone House Timber Lodge, it has a variety of places to rent and they rent boats as well. we love the place and the people are great to deal with.

http://www.lakegastonfun.com

check them out, you won't regret it.