Dundee residents left without water after mains pipe bursts