I really can't remember much about this other than the very start, or at least I think it's the start...
The movie opens with a mermaid trapped in a huge tank of water, as part of some freak show I think. Eventually the mermaid kills the man keeping her captive.
It's a recent enough film, made in the last decade I reckon. American production. Pretty gory, lots of blood and guts I think.