Missing child, 5, dies after being found in water