Using the terrain raisers/lowerers that come with the NAM are very useful because you can plop em anywhere on land or water. Also there is a trick that involves plopping the road to elevated road transition ramp. I forget the exact methodology, but if you plop it facing the water (or away, I forget) it will lift some of the land that is currently sea.