Flooding in western Germany has left six people dead and many missing, and caused at least six houses to collapse.