Everyone should be ‘mindful of their water use’ amid the heatwave, an Environment Agency chief has said