Kayaking Resource

I’m planning a vacation with my family for August. My brother wants to be able to use his kayaks so the vacation will be at a lake…but where? I’m looking for somewhere not in New York or New Jersey where I’m familiar with, where there are rolling mountains, beautiful scenery, and activities other than kayaking like horseback riding.

I am planning on kayaking around the pictured rocks in the beginning of August, but I have no idea of what to wear since it will probably be chilly. Any suggestions?
Any Kayaking fans out there?? The water will be about 54 degrees (f) and the air temp will probably be around 70 degrees (f).