I live in Portsmouth which is also part of the Hampton Roads area. I have camped at almost every campground around here - but of course, not this one.
I CAN answer any questions about the area you may have though.
North Landing Beach is located in the "Back Bay" area below Virginia Beach Oceanfront - it is VERY quiet and out of the way of all the tourists. Very pretty too.
But if you want to go to Virginia Beach Oceanfront area, you just drive up Princess Anne until you run into General Booth Blvd - hang a right on General Booth and it will take you right in. There's a water park, Ocean Breeze, I think it is called and the Marine Science Museum, to name a few things to do.