Beloved Scottish actor was also known for stints in 'Blackadder,' the James Bond franchise and numerous other film and television roles