Residents on Harrogate's Duchy Road lose water after pipe bursts