Well, a long way to do it would be to copy/paste two different tilesets (one with the only the land passible, and one with only the water passible), then when you get to a diving point, you transfer between the two maps with no fade. Simple enough to do with events, though there might be a quicker way to work it.