Or if you don't want to commit to building a pier or platform, could you moor a houseboat there?

It's worth noting that flooding isn't an all or nothing thing. I live on the New England coast and my neighborhood occasionally floods during storms. This is a disaster for some houses, but only a temporary inconvenience for others which are build on a tall foundation and have a raised area for parking.