Succubus

A supernatural being in folklore (dating back to medieval legend) who appears in dreams in the form of a woman in order to seduce men through sexual activity.

Male succubus is called an incubus.