Former England all-rounder Paul Collingwood is set to lead Scotland through the World Cup qualifiers having been named as new joint-head coach.