Rabbi Slifkin addresses Mermaides, concluding that they are probably dolphins, in a post entitled "The Wisdom of ArtScroll" (for once, not sarcastically) which he features in his book Sacred Monsters.
As a summary he writes:
"In brief: The Gemara provides a perfectly accurate account of dolphins. Rashi, however, for reasons that I discuss in my book, (mis)understood the Gemara to be referring to mermaids. Which, in the view of most (but not all) people, do not exist."
He then quotes the Artscroll:
“There are marine animals,” writes Rashi, “half of whose bodies are of human form, and half in the form of a fish. They are called sereine in French.” Rashi clearly refers to mermen (the French sereine derives from Latin siren, meaning mermaid), whose existence was widely accepted in the ancient and medieval world and indeed until recent centuries. (According to Raavad in his commentary to Toras Kohanim 3:7, sirens are mentioned as well in Toras Kohanim ibid.) As understood by Rashi, then, the Baraisa teaches that humans and mermen can interbreed.
Others suggest that the dolphins of the Baraisa are none other than the familiar dolphins of the order Cetaceans. These endothermic (warm-blooded) air-breathing mammals “reproduce as do humans” (following the variant kbnei adam) in that they copulate ventrum to ventrum (the manner ascribed to humans later in the Baraisa), bear live young, suckle their calves, and rear them intensively for six or seven years, to near adulthood. Dolphins were known by very similar names in the milieu of the Baraisa: Latin delphinus, from Greek delphis. Delphis is related to delphys, meaning womb, so that the genitive delphinos probably denoted [a sea creature] possessed of a womb; the very name dolfinin thus suggests that the animals in question “reproduce as do humans.” Rav Yehudah may have called dolphins sons (or people) of the sea because of their affinity for humans (they commonly approach and accompany boats), and because they often evince humanlike intelligence in their behaviors and social interactions.
So to answer your question: mermaids are actually dolphins. Primarily found in the sea.