The difference lies in the transmission properties of both transducers. While the narrow band transducers pass narrow band signals dictated by their narrow bandwidth the wide band transducers pass the input signals in larger bandwidth. The advantage of the narrow band transducer is that it could have better signal to noise ratio as the noise generated in the transducer is proportional to their bandwidth. So, the noise added to the signal is smaller in case of narrow band transducer. While the wideband transducer is more economical since it can detect multiple narrow band signal.
I believe you'll find that Q is nonetheless related to the degree of damping in the structure. The more damping, the lower the Q. This also implies structural losses to heat. Maybe that's also a fairly trivial statement but may be of some use in your pondering the answer to your question.
The more damping, the wider the bandwidth.
Of course, this suggests a model of a transducer to make it clearly understandable. In the model diagrams in www.ultrasonic.co.ir/files/003.pdf Figure 1, R1 provides the damping function.
The noise will increase with bandwidth but probably originating in the environment and not the transducer itself.