Water resource management and solutions