Stafford McDowall 'over the moon' to lead Scotland in Canada