A huge transformation has taken place in Orkney to make it the setting for the largest international multi-sport event to ...