Another modest fountain in Downtown Houston that I've always liked is the Smith Fountain. https://live.staticflickr.com/3373/5...4e613a3d_h.jpg
Smith Street at Dusk, Downtown Houston by Dave Wilson, on Flickr

https://live.staticflickr.com/7305/1...a6aada6b_h.jpg
Fountain, #houston #downtown #allenpark #smithstreet #chevron #bayoucity #sunset #bankofamerica - Filename: XR6A1116_HDR - f/13 ISO 100 by Taha Raja, on Flickr

https://live.staticflickr.com/4036/4...16991801_h.jpg
The Bob and Vivian Smith Fountain from the sky by imelda, on Flickr

Also, Main Street Square has a water feature for the light rail to run through.

https://live.staticflickr.com/4649/3...4d981c8e_h.jpg
Main Street Square by Raul Cano, on Flickr

https://live.staticflickr.com/65535/...61ed51b0_h.jpg
Houston Downtown Metro Light Trails by Yoo-Sang Choo, on Flickr

https://live.staticflickr.com/2512/3...a537e7c0_h.jpg
Houston Metro Fountain Tracks by Dan Pancamo, on Flickr

Here are a few of my images of that cool treatment:

Water Feature: Metrorail route in downtown
Location: Houston, Texas

https://imagizer.imageshack.com/v2/xq90/924/FjnQoN.jpg

https://imagizer.imageshack.com/v2/xq90/923/rRoqJ1.jpg

All photos taken by geomorph in 2010.

Only if you settle for an extremely elaborate, to the point of being overdone, classically styled fountain that, for no discernible reason, decorates the parking lot of a strip mall in East Asheville.

It is magnificent! At first, I mistook it for Versailles, but upon closer inspection I concluded that it is what Louis had intended for Versailles!

Water Feature: Portofino Bay Resort
Location: Orlando, Florida

https://imagizer.imageshack.com/v2/xq90/924/DEsWmU.jpg

https://imagizer.imageshack.com/v2/xq90/922/5ozTeb.jpg

All photos taken by geomorph in 2011.

Water Feature: Citygarden
Location: Saint Louis, Missouri

https://imagizer.imageshack.com/v2/xq90/923/PNwzpr.jpg

https://imagizer.imageshack.com/v2/xq90/924/xJLpjJ.jpg

All photos taken by geomorph in 2009.

Water Feature: Sacramento Convention Center
Location: Sacramento, California

https://imagizer.imageshack.com/v2/xq90/923/Fumvnh.jpg

https://imagizer.imageshack.com/v2/xq90/922/VHQkhn.jpg

All photos taken by geomorph in 2013.

Water Feature: House of Hospitality in Balboa Park
Location: San Diego, California

https://imagizer.imageshack.com/v2/xq90/922/weiM8k.jpg

Photo taken by geomorph in 2014.

Water Feature: Guardian of Water at San Diego County Administration Center
Location: San Diego, California

https://imagizer.imageshack.com/v2/xq90/922/DTgoba.jpg

https://imagizer.imageshack.com/v2/xq90/922/Ghooe3.jpg

https://imagizer.imageshack.com/v2/xq90/924/ewUlLe.jpg

https://imagizer.imageshack.com/v2/xq90/923/Gr1wcO.jpg

All photos taken by geomorph in 2014.

Water Feature: Women's Building at Fair Park
Location: Dallas, Texas

https://imagizer.imageshack.com/v2/xq90/923/M2NOyQ.jpg

https://imagizer.imageshack.com/v2/xq90/922/HCPG3D.jpg

https://imagizer.imageshack.com/v2/xq90/923/jVpbwg.jpg

All photos taken by geomorph in 2013.

Water Feature: Entry Sign for Hollywood Bowl
Location: Los Angeles, California

https://imagizer.imageshack.com/v2/xq90/923/oYYkvB.jpg

https://imagizer.imageshack.com/v2/xq90/922/FnFizW.jpg

https://imagizer.imageshack.com/v2/xq90/924/IRHTGZ.jpg

https://imagizer.imageshack.com/v2/xq90/923/bvFIhI.jpg

All photos taken by geomorph in 2008.

Water Feature: Henry B. Plant Museum
Location: Tampa, Florida

https://imagizer.imageshack.com/v2/xq90/922/ZwwSbK.jpg

Photo taken by geomorph in 2019.

Lady Justice Fountain, Bexar County Courthouse. San Antonio.
https://live.staticflickr.com/880/42...53321ccc_h.jpg
Bexar County Courthouse by bill barfield, on Flickr

Water Feature: Holocaust Memorial Miami Beach
Location: Miami Beach, Florida

https://imagizer.imageshack.com/v2/xq90/924/a4uYLF.jpg

https://imagizer.imageshack.com/v2/xq90/923/CCHmML.jpg

All photos taken by geomorph in 2007.

Water Feature: Cinderella Fountain at Walt Disney World
Location: Bay Lake, Florida

https://imagizer.imageshack.com/v2/xq90/924/9I7OZa.jpg

Photo taken by geomorph in 2010.

Water Feature: Crow Collection of Asian Art
Location: Dallas, Texas

https://imagizer.imageshack.com/v2/xq90/922/FtrGhG.jpg

https://imagizer.imageshack.com/v2/xq90/924/QJE21f.jpg

https://imagizer.imageshack.com/v2/xq90/922/LF4Tay.jpg

All photos taken by geomorph in 2013.

Dallas and Ft. Worth both have those really nice, big water gardens.

Water Feature: Monument to Labor at Lewis and Clark Landing
Location: Omaha, Nebraska

https://imagizer.imageshack.com/v2/xq90/922/8NNTlU.jpg

Photo taken by geomorph in 2009.

Water Feature: Father and Son at Olympic Sculpture Park
Location: Seattle, Washington

https://imagizer.imageshack.com/v2/xq90/924/l6dr9D.jpg

Photo taken by geomorph in 2009.

Water Feature: Peace On Earth at Los Angeles Music Center Plaza (renovated since this photo was taken)
Location: Los Angeles, California

https://imagizer.imageshack.com/v2/xq90/922/ZJNhGU.jpg

Photo taken by geomorph in 2008.