Leak causes loss of almost one million gallons of water