Strangely enough, I have done something like this
It’s a little hard to see here, but the rock is higher than the water.
I did it with world position offset, this is how it looks in the instance:
The material’s a bit of spaghetti junction, but it’s just a heightmap and WPO