A community shed has officially opened in North Yorkshire after six years of hard work and collaboration by volunteers and supporters of the project.