Multi-million pound holiday retreat to open its gates for artisan market and charity garden celebration