The Scottish actor presided over the adventure game show from 2002 to 2010, taking the gruff and mysterious titular role that set challenges for young warriors