Around 6,000 properties were initially affected after damage was found to a pipe at Rawburn Water Treatment Works on Tuesday.