The effect that you are seeing can't be seen with the naked eye. The effect only works through the camera. However, there is a version of the project you can do where the effect would be visible with the naked eye. For that project, you'd have to use a strobe light.
For this project you'll need:
A powered speaker
Water source
Soft rubber hose
Tone generating software
24 fps camera
Tape.
Run the rubber hose down past the speaker so that the hose touches the speaker. Leave about 1 or 2 inches of the hose hanging past the bottom of the speaker. Secure the hose to the speaker with tape or whatever works best for you. The goal is to make sure the hose is touching the actual speaker so that when the speaker produces sound (vibrates) it will vibrate the hose.
Set up your camera and switch it to 24 fps. The higher the shutter speed the better the results. But also keep in the mind that the higher your shutter speed, the more light you need. Run an audio cable from your compute