It will be named after the James Bond actor, who worked as a milkman in the Scottish capital before becoming a Hollywood star.