Two thirds of self-harm cases seen in hospital emergency departments last year involved an overdose, according to new data.