General George Duncan Gordon (1770–1836), 5th Duke of Gordon, 'Cock of the North'