Fountains choreographed to music also generally called musical fountains are the latest budget sites in case you visiting a tourist destination.

Fountains of Bellagio, Las Vegas

The Fountains of Bellagio is a vast, choreographed water feature with performances set to light and music. The performances take place in front of the Bellagio hotel and are visible from numerous vantage points on the Strip, both from the street and neighboring structures.
The fountain display is choreographed to various pieces of music.

Fountain of Nations, Lake Buena Vista, Florida

The Fountain of Nations is a musical fountain at Epcot in the Walt Disney World Resort in Lake Buena Vista. The fountain plays a variety of music, some of which comes from old Epcot and Walt Disney World attractions. The automated shows are performed on every quarter-hour.
The fountain also dances to the music until the park is fully cleared out so people can watch it after the firework show.

The Singing Fountain, Czech Republic

Singing Fountain in Czech spa town Marianske Lazne is one of the most popular creations of master artist Pavel Miksik. It is a complex sound-water-light piece which provides daily concerts.
The fountain contains 10 water jet systems with more than 250 water jets. The water gushes from the water jet in the center up to a height of 6 meters.
Opening music piece is a song by the Czech composer Petr Hapka followed by works from Chopin, Mozart, Bach, Gounod, Smetana, Dvorak and others.

Hydraulophones, Ontario

Well this would be very small in terms of size to any of the fountains mentioned in the list, but it’s equally musical and entertaining. The fountain at Ontario Science Center also called a hydraulophone is a center of attraction for visitors. Anyone walking into the center can play it. Blocking the flow of any one of the 57 water jets in the fountain forces the water across to a corresponding organ pipe, where it makes a loud sound as the water is forced out through the speaking mouth of the pipe.