Optimizing irrigation water use for resource sustainability