Is there a spell to become a mermaid that actually works?

No. There are no spells to make you into a mermaid. Spells are not real and can not turn people into anything or a mermaid. Mermaids are not real so it is all make believe.