A statue of the war veteran has been unveiled on the Royal Mile, where he collected more than £1 million for charity over the years