I've got one of
these, it cost a whole £35 including a decent supply of smoke fluid.
It's tiny and produces far more 'smoke' than I need, it's just about perfect for my needs.
It's possible to fit a hose, using a jubilee clip, to the outlet. Attach the hose, feed the other end into a bucket containing water, put plenty of ice cubes in the bucket and you'll end up with 'smoke' that's heavier than air and so which will lie at low level instead of rising too much.
The only important things to remember are
1. Make sure the smoke is in front of the subject, otherwise your shot will look like you added it in post
2. Make sure your machine uses water based, not oil based fluid
3. Work out how much smoke you need for the shot and then use a tenth of that amount

4. Backlight the smoke
5. Switch off the smoke detectors
6. Don't forget that it takes an age to clear afterwards