A popular beauty spot issued a 'do not enter the water' plea amid the heatwave which has seen experts issue a health warning.