Durham skipper Paul Collingwood will join Scotland's coaching team this winter ahead of two World Cup qualifying campaigns.