It is never proper to say “It is raining cats and dogs.” The correct phrase is “dogs and cats,” not the other way around.