Core/Spells: Implement Periodic mechanics

Change behaviour of periodic aura ticks to be more blizzlike
Also add some missing handling of SPELL_AURA_MOD_CREATURE_AOE_DAMAGE_AVOIDANCE
Fixes Deep wounds, Piercing Shots, Ignite