I think the, It's pissing down, sounds similar to something we would say.
The references to Ducks and frogs are self explanatory while the cats and dogs is a mystery to me.
Now I begun thinking that in a country where rain is very common. There will naturally be more and broader expressions for describing the rain.