William Simpson, Provost of Inverness (1846–1852)