The Providence, Rhode Island area was slammed with rain leading to heavy flash flooding in the streets