The main difference is capacitance; super-capacitors have much higher capacitance than conventional capacitors. As a result,, super-capacitors can store much higher energy because Capacitor_Energy = 0.5(capacitance)(Voltage)(Voltage).
It is also worth nothing that in Power Generation, Transmission and Distribution, there are also capacitors with operating voltages in the range of thousands Volts. Those capacitors store much higher energy levels but they are specialized for high voltage applications. Super-capacitor operating voltages are limited to few hundreds volts.
Conventional capacitors use solid dielectric medium between the electrodes. To the contrary, supercapacitors use liquid electrolytes to separate the two electrodes. Typically, supercapacitors have much higher capacitance than the conventional capacitors. Both are used for energy storage but the supercapacitors are capable of storing more electric charge. With respect to cost, supercapacitors are more costly than the conventional ones.