Urban water sustainability: framework and application