Excessive fluoride intake can lead to conditions like dental fluorosis in children and skeletal fluorosis in adults, both of which affect the appearance and strength of teeth and bones, respectively.