A £400,000 grant given to an events company co-owned by Greater Manchester's nighttime economy adviser has been pulled following a review - with Sacha Lord announcing he has decided to leave the role.