The North Staffordshire beauty spot ranked among best waters