Wampler Lake would be a great place for kayaks. Shoot, you could probably spend a week exploring all the nooks and crannies of that one pit! Plus you'd have another 100+ pits to explore if you got tired of that one.
Close up of the campground, most all of the sites are on the water.
The drawback to Greene-Sullivan is that it's primitive camping only with pit toilets. Reservoir 26 has a campground, it's nice, but below the dam and not on the water. The fish cleaning station is across the road from that campground. It's been so long since I've been through the Narrow Lake campground that I can't remember if there's any sites on the water.
I'd like to recommend Shakamak State Park, but the campground is about in the worst part of the park they could have put it in. It's fairly close to Lenape Lake, but the water is down a big hill. Shakamak S.P. was an awesome place to stay back when the campground was over on Kickapoo.
Like Dee was saying, Dogwood has a really nice campground. I don't think there's any sites directly on the water that I remember though? Paynetown on Monroe has some good sites. I wrote all the best ones down when I was there once and I'll post them if I can find my notepad.(Might have gone with the RV when it sold.)
Another campground that not a lot of folks other than locals know about is Fowler Park, ran by the Vigo County Parks & Rec. It consists of a lake and a few other small pits...the main lake is the one with the road around it, the pits are the 2 small ones to the left of the lake(kind of a big hill to climb to get to those), and the long pit to the right.
The majority of the sites are right on the water, including a really cool tent site on a point by it's self. There's a couple shower houses there(1 nicer one that was built just a few years ago.)
Close-up of the Fowler campground...
Another cool thing about Fowler is the pioneer village with a covered bridge going across a small neck in the lake...
Fowler was always a favorite of the wife and kids. The kids loved it because they could roast a wienie in one hand and hold a fishing rod with the other.
The first choice for me would still be Greene-Sullivan though. I'm gonna convert back to tent or hammock camping this year and spend some time there myself.