I would stick with regular tights and buy rain-legs in case it's torrential. (they're cheaper than any good tights, for one thing!)
You will almost certainly get some chance to dry out; you want leg-coverings that let that happen while you're pedalling, and standard roubaix does this very well. It's also not at all restrictive; your leg movement is quite important!
Of course some seem to survive in shorts ...