Unable to answer "Is drinking water freely available to campers here?" – The Headland Caravan Park (RV Park) – https://osm.org/way/142439029 via StreetComplete 59.2:

Campsite now closed and all facilities removed

Attached photo(s):
https://westnordost.de/p/248280.jpg