At least three people have died and two remain missing after heavy rainfall and storms caused flooding in southern France since Monday.