I have my own fond memory of a New Zealand fountain in Dunedin on the South Island. I am googling as I speak as can't even remember its name. Got it, Star Fountain. Damn, it has been demolished.
It was quite kitsch, I suppose, but it amused me with its synchronised lights, bright classical music and water jets. The area known as The Octagon was renovated in the 1990s and the fountain never reinstated, in spite of local agitation. I do rather agree that during the day, the pipes were not the most attractive thing. Too early for You Tube, methinks, but here are some photos.