Shoppers have revealed their "excitement" after a supermarket revealed plans to open its first store on Franche Road in Kidderminster.