Hosepipe ban affecting 350,000 comes into effect for first time in 30 years amid record breaking heatwave