Water resources long term planning framework