You can use Bloodlust as the base ability if you want the spell to target allies or Frenzy (Quilbeast autocast) if you want it to only target yourself. Then you add the Vampiric effect through triggers by adding one of the many Lifesteal abilities to the caster of said base ability. The trigger will depend on which effect you want, self cast or ally cast.