Video footage has captured the dramatic moment cars were carried down a street by water after the flash floods that have killed at least 51 people in Valencia.