The legendary Tartan Army hero sadly passed away at the age of 84 following a battle with Alzheimer's