Can you turn into a succubus?

No. A succubus (incubbus) is a form of demon. Outside of the universe of Supernatural, humans and demons are different beings; one cannot become the other.