A landmark building in the heart of Huntly has officially reopened its doors as a dynamic new community space, following a major redevelopment.