From Wikipedia: Lorelei is a feminine water spirit, similar to siren or mermaid.
Not from Wikipedia: If I remeber correctly she sat on a stone on the Rhine and lured boats near it with her songs wich lead to them sinking and many people drowning in the river wilds.