The Mayor of Cambridgeshire and Peterborough Combined Authority has announced that he will not be standing for re-election in May.