Nicholas Paget-Brown, the leader of the council dealing with the Grenfell Tower fire, has resigned following criticism of his handling of the disaster.