Republican, royalist, chaplain, schemer, spy – the builder of Downing Street was a man of multiple identities