A burst pipe is sending thousands of gallons of water towering into the air, drenching neighbouring properties and leaving stunned residents without supplies while the UK is on drought alert.