First, a parody of the Little Mermaid that was made into a real life

Movies – Splash

A romance movie with a setting that turns into a tail when it touches water and becomes a bridge when it wipes off all the water