Roads and pathways swallowed by water as flooding caused by heavy rain left Britain's longest river bursting its banks