A planning application to host weddings and retreats at Moat Island Glamping in Haveringland has been withdrawn after sparking local opposition.