Scottish rugby legend and Motor Neurone Disease (MND) awareness campaigner Doddie Weir has visited Dundee to see an Oor Wullie statue created in his honour.