Council leader Nicholas Paget-Brown has stepped down over "perceived failings" following the Grenfell Tower fire disaster.