Why Is There Fluoride in Water? Is It Effective?

Based on nearly 100 randomized controlled trials, fluoride toothpaste reduces dental cavity rates, but what about just adding fluoride to the water supply?