A much anticipated garden centre has officially opened its doors as locals queue to get a glimpse inside.