The Dordogne River
The river is literally 1 km away, 5 minutes on a bike. You can go swimming, but be careful and of course kayaking, canoo or fishing are all possible.
It is protected, that means no boats are mored in the river and its banks are wild.