How to create a mechanical vibration?
I would go purely mechanical. 

This is my 10 seconds though design: a stepper motor with a cog but with sinusoidal serrated edge. That drives a lever, the pivot position of which determines the amplitude, the end drives your tube.