Manderston, John, active 1817-1828, Lord Provost of Edinburgh