The prime minister’s former chief of staff, who was responsible for the Partygate investigation that helped topple Boris Johnson’s government, will become a life peer