Modelling crop yield, water consumption, and water use efficiency for sustainable agroecosystem management