Pretty village being torn apart by 'drugs and rowdy tourists' at holiday park