A state of emergency has been declared in Louisiana after torrential downpours caused dangerous flooding that killed at least two people and forced evacuations.