Sin wave, square wave, or other? Fixed frequency or variable? How long is the cable and what is the piezo capacitance? How accurate does the amplitude have to be and what is your tolerance for reflections.
If you just need a square wave drive mosfet switches will do this fairly easily. If you want a sine wave you can add an inductor to make the piezo resonant and make it much easier to drive.