Cancer-causing "forever chemicals" have likely been present in a tourist hotspot's drinking water for decades, a major investigation has found.