A few concerns with this design...
The "tranquil water sounds" will be wasted, as chams don't hear anything other than very low frequency vibrational sounds. The manufacturers of this fountain know NOTHING about cham biology.
The activated carbon pad filter may not be able to cope with the bacteria load of dead feeders, leaves, or fecal matter than happens to fall into the water. I'd suspect the filtration is designed to handle small bacteria loads (such as when the water gets stale, exposed to dust, or when a pet drinks out of it...you know, the similar types of fountains for cats and dogs) without completely clogging up. One dead feeder could create a noxious water source very quickly.
Depending on how easy the fountain's surfaces are to disinfect or clean, it may end up being a hassle to maintain over time. Same problem most keepers find with the terrarium waterfalls/fountains on the market. Someone will still have to keep the reservoir clean and filled.
Just because you put a fountain in a cham cage does not guarantee your cham will use it. They have to learn its a source of water, and many chams never do. If the water circulating in this fountain doesn't happen to move enough to attract the cham's attention (they are attracted to the glistening of moving or dripping water) it will end up being a waste of money.
And, one of the main reasons we mist our chams is to provide cage humidity. This fountain won't really do this so someone would have to mist it anyway. Or, you'd need a auto mister setup in addition to the fountain. It won't really replace that.