Horticulture director David Knott said welcoming people back to the Palm Houses will be a ‘hugely amazing experience’