If you stick to public parks (COE, Fed, State, County, etc.) you will rarely find permanent residents (there are exceptions). There will also be larger sites, though often without sewer and sometimes water or electric. There will often be wonderful walking areas and hiking trails, but much less often, pools and mini golf.
USCampgrounds.info is one of the most comprehensive sites listing public campgrounds. One can also check Reserveamerica.com, which will list many public sites.
RVparkreviews is a good resource but don't rely on the ratings. Many people will mark a campground down 3-5 points for not having a sewer at their site, or not having a swimming pool, or wifi, or cable tv. Read the reviews themselves to get a better feel of the campground.