Is there any loot? Will he stab me?
Of course there's loot! And no, he won't stab you - he's dead. Look at how dead this idiot is. He's not stabbing anyone.
Loot-wise, you can find a golden crucifix laying on top of the vampire, and a golden chalice on top of a barrel near his coffin. Sell them both, and you're looking at a payday of roughly 2010 Groschens. Not bad at all!