The Tyler Davidson Fountain stands at 43 feet and is cast in bronze. It is also sits on a granite base. The entire construct is made of approximately 24 tons of bronze and 85 tons of granite. It also features a nine-foot tall bronze statue of a woman with outstretched hands out where streams of water flow. It is estimated that 500 gallons of water flow through it every minute. The fountain has its proper name is The Genius of Water. One can see several smaller central human figures surrounding the fountain. These figures represent the practical uses of water. The four outer figures with animals represent the pleasures of water. These were actually working drinking fountains before having panels on its lower part, colloquially referred to as “The Fountain”, which depicts the industrial uses of water.

Surrounded by stores, hotels, restaurants and offices, the Fountain Square and the Tyler Davidson Fountain underwent renovations in 2006. They were removed and then later put back but in a different location. It was moved further up towards 5/3rd Bank. The fountain is turned off each winter and turned on again in April for the first home game of Major League Baseball's Cincinnati Reds, the oldest professional baseball team.

The Tyler Davidson Fountain was cast in separate sections at the foundry and shipped to Cincinnati for assembly. Henry Probasco, Davidson’s brother-in-law and business partner, requested that the City of Cincinnati remove the dilapidated market along 5th Street between Vine and Walnut Streets for the water fountain. In its place a walkway bisecting 5th Street was built. The walkway was designed by the architect William Tinsley. Tinsley also designed the Henry Probasco House in the suburb of Clifton. The path made the water fountain easily visible to anyone traveling by. Ferdinand von Miller, who made the designs for the fountain traveled to Cincinnati for the dedication ceremony, which took place on October 6, 1871. Around 20,000 people were present at the event.

Originally facing east, towards Europe, where much of Cincinnati's population originated, the Fountain Square was redone in the late 1960s. It was realigned to face west. With the newest rendition of Fountain Square, the fountain faces to south since it is in the back of the square. In celebration of its centennial, the fountain was renovated for the first time in 1970. The Fountain Square plaza was also redesigned for better traffic flow, and the fountain was moved and turned to face west rather than east. In 1999, additional repairs and another refurbishing project were undertaken. In addition, the city decided to move the entire fountain to the center of the Fountain Square in 2005 in part of the revitalization of the square. The estimated cost was reportedly around $42 million with the city shelling out $4 million.

Fountain Square reopened on October 14, 2006. It was on display at the Cincinnati Art Museum during the renovation. It was once again shown to the city with an elaborate ceremony that included different stages for multiple bands, food, beer and fireworks. Aside for continuing to be a backdrop for various cultural events in Cincinnati such as movie nights, game shows, and the ice rink which opens in the winter, the fountain is also most familiar to non-Cincinnati residents for being featured in the opening credits of the television series WKRP in Cincinnati at its former location.

Kansas City also known as the city of fountains has a large variety of water fountains for the public