Role of Economic Diversification in Sustainable Water Management : A Socio-Hydrological Analysis