I have something like this for Sims 2, would also love to get a similar mod for Sims 4!
There's something that might work, but I'm not sure if the mod is still getting updates. It's called Andrew's sfx player. You place a small plumbob-like object on your lot and type in what effect you want to play, either on command or continuously. A list of effects is provided with the mod, my favorite was the sea serpent from Windenburg that I summoned into a reserve, for your flooded room I imagine any waves sfx might work.