Major incident declared as 30,000 homes in UK left without water