Dig canals to extend or connect bodies of water. - Adds waterfill and swimming - Biters, players, and vehicles are slowed down in water
I believe they added a new water tile in 0.17 that specifically allows walking/driving on if you wanted to use that instead of changing other tiles.
You can't build offshore pumps in shallow water though.