Whether biking to castles or kayaking through gorges, a trip centred on this river is the epitome of European romance.