Menacing, magical and moving tale of loss will enchant Aberdeen audiences