Haringey Council leader George Meehan and cabinet member for children and young people Liz Santry have resigned in the wake of the Baby P scandal.