There is high quality evidence that fluoride at levels contained in some US water supplies is associated with lower childhood intelligence. For lower levels, the conclusion is "we don't know", not that there is no harm.
https://ntp.niehs.nih.gov/whatwestudy/assessments/noncancer/...
There is also high quality evidence that in the age of fluorinated toothpaste, fluorinated water "may slightly" improve dental health.
“The evidence suggests that water fluoridation may slightly reduce tooth decay in children,” says co-author Dr Lucy O’Malley, Senior Lecturer in Health Services Research at the University of Manchester. “Given that the benefit has reduced over time, before introducing a new fluoridation scheme, careful thought needs to be given to costs, acceptability, feasibility and ongoing monitoring."
https://www.cochrane.org/news/water-fluoridation-less-effect...