A "unique" lifestyle store offering a "quirky" range of products is set to open in the heart of a Huntingdonshire town.