Mean water balance dynamics and smallholder management options for improved agro-ecosystem productivity