North Beach Campground (Airstream dealer Sky River RV is across the street) is really nice, but all dry camping. Right next door (north) is Pismo Coast Village. PCV is nice, but packed tight, we usually don't go there except in the off season. We will actually be there for a week in September. You can kinda compare the two campgrounds right here.
Google Maps
We've also stayed in Pismo Sands and Pacific Dunes. One of our new favorite spots is further north, Morro Bay State Park.