You want a piezo transducer (speaker) not a piezo buzzer that has a built-in oscillator that produces only one frequency.
The frequency response of a piezo is all over the place so some frequencies will be very loud and other frequencies will be hard to hear. You might need to adjust the frequencies.
Here is the frequency response of a typical piezo transducer:
Your spec 110 decibels is loud, on a par with automobile horns. Such a buzzer no doubt requires more power than my little circuit can deliver (post #3).
You mention LM328 op amp. I think that also is too weak (in terms of its Ampere capability).
You need an oscillating circuit that provides sufficient volts and Amps. It might be built from transistors or mosfets or a power op amp.
All of the buzzers (transducers) except the "musical" one are in a tuned resonant case at a few high pitched beep frequencies. The loudness is only 85dB to 90dB when it is measured at a distance of only 30cm (one foot) and drops 6dB for each doubling of distance.
There are no details about the bandwidth of the tuned ones or the frequency response of the musical one.
They do not say if the signal you feed is a sinewave or a squarewave.
If you feed one of the buzzers the AC frequency you want then there is no information (bandwidth) showing the loudness.
The lack of information is maybe because the company is in India.