Hundreds turned out for the official re-opening of the Red House Glass Cone following a £1.5 million restoration.