Major-General Sir John Campbell, Bart