Though flooding left homes waist-deep in water and submerged cars, officials said the dam system operated as designed for flooding emergencies and no injuries were reported