The Commonwealth Games 2014 logo has been unveiled: Clyde the Thistle Man.