Heavy rains and flooding have left six people dead and displaced tens of thousands in Brazil's northeast.