Manchester’s nighttime economy advisor has stepped down over a “small number of unintended oversights” his events company made in a £400,000 Arts Council grant awarded during the pandemic