The dog came over to play with the water the minute we turned it on!

I used to have one of these and my maltese loved it. It was a pain to clean the pump though! I would never have one again.
Thought the rocks would keep out leaves and debris but they find their way in there and then the pump clogs and stops.

I too, would be concerned about the safety of my pets drinking the water. How safe is that?

Great idea and the kids will love it BUT be careful of barrel chested large breeds. They are at risk for torsion bloat. the bubbles can trigger this.

what is the kit called

The kit is from Aquascapes. It is for their disappearing jar fountain.

I wouldn't worry about water quality for dogs. They drink from toilets and puddles given the opportunity! I think if you had a bio filter you'd only need to clean it a few times/year.
You'd have to add water frequently as evaporation would probably be an issue.