An adviser to Greater Manchester mayor Andy Burnham has resigned following an investigation into a grant from Arts Council England (ACE).