For small Van de Graffs is often mechanical friction at the source, on the belt, then accumulation of charge (with fixed capacitance: ball to ground) ==> voltage increase.
There are many traditional machines that used static.
Google Whimshurst machine?
https://en.wikipedia.org/wiki/Wimshurst_machine
Have you seen the one where two flows of water fall through rings, breaking into droplets & spontaneously charging the vessels?
https://en.wikipedia.org/wiki/Kelvin_water_dropper
.
Generator? No.
As in something that converts mechanical energy to electrical?
Also there is an old experiment where you join & separate charges metal balls.
Basically after charging the plates of a capacitor, if you increase the separation of them the capacitance goes down, so for a fixed charge the voltage goes up.
You can also induce charges on adjacent pairs of spheres (touching each other), then separate the pair, so you have effectively charged a capacitor. You put mechanical energy into the system when you separate them from the inducing static charge, or each other: that is opposing the attractive force of the electrical charges. Check out a physics book on static electricity.
Sorry, couldn't find a link just now.
As above: generally negligible amounts of energy.
.
Piezo, as in those devices that help you light your gas. Hit/deform the crystal, voltage results.
https://www.americanpiezo.com/piezo-theory/generators.html
.
Might also want to google energy harvesting, rectennas,