Need I mention the coast? OBX is one of a kind as well. You lucky guy. Welcome to NC!
Well said!
The NC Wildlife Service runs three "Public Fishing Areas" at Jordan; the only one with a pier is Bell's Church. Take US 64 almost to the east side of the lake, turn north onto Farrington Rd, which is the one with the signs pointing to Crosswinds Marina and Crosswinds Campground. Pass both, cross the bridge, and immediately on your right is Bell's Church. There's a driveway off their parking lot to another parking lot down by the dock.
This time of year, the dock is usually pretty popular with Crappie fishers after dark. The times I've been out there late in the day, there wasn't room for lawn chairs -- too many wagons. The dock has railings all around and built-in benches, so as long as you can avoid the crowd, it's a plenty comfortable place for your family.
Don't know about renovations -- my neighbor had been heading out there fairly frequently a few weeks ago, he didn't say anything about renovations...
The other two Jordan PFA's are just somewhat-clear bank areas. The PFA's are not within park gates -- I've asked, and they are available 24x7.
There's a map on ncwildlife.org of their Public Fishing Areas, but I wasn't able to put my cursor on it right now... but I did find this booklet, it looks promising as well...
http://www.ncwildlife.org/pg03_Fishing/pg3f_piedmontstreams.pdf
If you're close to Wheeler and Johnson, you're not far from Lake Raleigh on NCSU's Centennial Campus. I've heard good things about Johnson and the Big Lake at Umstead, but haven't spent much time on either.