Optimizing Water Supply for Reliable Service