The Guardian travelled 100 miles along the EU’s longest river, where some residents are struggling to secure drinking water