We ran across a nifty little area in Cary. There was a winery, and a park with hiking, and a small lake with canoe, paddleboat, and these mini sail boat (don't remember the exact name) rentals. It was incredibly populated too!There was also a boardwalk and picnic areas and VERY nice bathroom facilities. We're planning on getting a canoe, Old Towne to be exact as they don't tip nearly as easily.
It's nicely hidden as you can see the office buildings behind Mark. We really just ran up on this place, but we certainly plan to return. With our canoe.