A burst in the network has led to discoloured water in Deeside.