Methodology for assessment of water management options