A giant fire-breathing dragon will wake from his year-long slumber tonight to terrify and thrill at a Halloween parade through Cork City.