At least 117 people have died and others are still missing after heavy flooding in Nigeria, an emergency official said.