Managing Public Water Infrastructure with Resource Constraints