Andy Sheridan’s nocturnal compositions of a city at rest joins the great tradition of the fl√¢neur, writes Ros Kavanagh