just like the river Sio does when leaving my little lake So I could just raise the lake if I added it as a sea province, and then get the blue colour effect?
You have to modify topology, river map and terrain map.
On river map, if the river goes through the lake you need to continue running "under" the lake. (take a look to what we did for russian lakes).