This looks like a fun 3d printing project. I've been looking for an excuse to pick up a mini fog machine for photography.
The professional grade units in Norman's video are $150 and $250, but there are plenty of listings around the $50 mark.
They are basically just vapes with a small fan. IIRC, the special smoke fluid is just the vegetable glycerin base typically used in vape products.