There are some subsidary questions to ask here - what gene are you wanting to express, in what cell line, and how long for? CMV is a strong constitutive promoter working for most mRNAs, and interacts with RNA Polymerase II. U6 on the other hand is a Pol III promoter that in the cell makes small RNAs, so I would normally choose CMV for large RNAs and U6 for small ones.
But the level of expression after transduction will also depend on the cell type you are transducing and the vector you use. By transduction I assume you mean using a viral vector (as opposed to using transfection). Before you start your experiment, read about the differences between adeno, adeno associated, herpes and lentivirus based vectors. Which one will best suit your cell type? Be aware that you need an integrative virus if you want stable transduction, but that some take longer than others to establish maximum expression. Be aware that you can get higher titres of viral vector with some systems than others, and that some are more toxic than others.
But also be aware that sone cell types (such as macrophages) are much more difficult to transduce or transfect than others (e.g. 3T3's). In the end, as suggested by Joe Martarlo, you cannot predict expression levels very well, and you will have to measure them after a pilot experiment.