Directly it cannot cause rough idle. But if your engine overheats as a consequence of this situation, then it can. So, when you have a bad water pump, replace it as soon as possible in order to avoid this type of situation.