Improving Local Water Supply Resilience And Reliability During Drought: Computational Analysis And Identification Of Alternative Water Management Issues And Solutions Under Deterministic And Stochastic Environments