A fountain capable of shooting water up to 40ft (12m) in the air is set to be installed in Hull's Victoria Dock after £25,000 was approved for the project.
The fountain would help improve water quality and cleanliness in the Half Tide Basin, Hull Council said.
A spokesperson said water quality in the area had been a concern for residents for many years.
Councillor Jack Haines said the fountain would create an "impressive display".
Mr Haines, council communities portfolio holder, said the fountain spray could reach up to 50ft (14m) in diameter.
"The fountains have been a concern for residents for many years as has the quality of the waters within the dock and wildlife habitat," he said.
Councillor Haines said the water feature had the potential to improve community wellbeing as well as "the cleanliness of the local area".
The Local Democracy Reporting Service said the Half Tide Basin sits at the centre of a residential area with blocks of flats on three of its four sides and the south side facing the River Humber.
A spokesperson for Hull City Council said the area was also a tourist attraction for the city, historically hosting City of Culture events "when the water quality allowed for this".