If you sneak up on a sleeping NPC, you can feed on them, reducing your vampirism back one stage per feeding. People are only automatically hostile if you're a blood-starved vampire.
If you want the quest to cure it, just visit an inn and ask the inn keep about rumors. You'll find out easily enough from there.