The river itself flows through changing terrain , from its source in the Auvergne mountains through deep gorges to fertile lowlands and on to the sea near Bordeaux .
The river ends in a large lake with no outlet .