The Labour leader will travel north of the border for the 2026 Commonwealth Games in Glasgow.