Managing water resources for crop production