Some undead can go underwater too. And in the very late game there's a spell called Thetis' Blessing that let's all land units go underwater, but it does require water magic.
Reading the posts on this forum helps, there's a lot of useful information on here, and for the rest I just figure it out. ( I never said I was any good mind you... )