This powerful poison is said to have the power to transform werewolves and heal snake bites. Brian Clegg unpicks fiction from fact