The former Magpies star has died after a long health battle