In Paris in the '90s they used big green dirt-bikes equipped with a giant tank on the back and a hoover nozzle resembling an elephant’s trunk up near the front fork.
The operator (who was dressed like Super Mario only in bright green) would bounce the contraption up onto the sidewalk, pull up alongside the intended target, lower the nozzle onto the dog-poop and with exactly the Schlooooop-Pop! noise you’re imagining, the problem would be solved.
People think Luc Besson movies are science-fiction, but that’s just what Paris is like…