Yes, it will let you play all of the CPS3 games, though there's far fewer of them than there are CPS2.
As to where to buy it, you need a working Street Fighter 3: Third Strike setup (or its equivalent) and then one of several people can convert the security cart with the SuperBIOS code.