Planning and management of a transnational water system