I remember my trip to Spain being spent in a lot of ir de tapas. But at that time my drinking was moderated. Having drinks is more routine there, but I think the touristy stuff over-emphasizes it. I know there are people in Spain doing other things in the evening and there are alcoholics there too.
I might consider alternatives to this crowd of people. Because there is no way I know of to change drinking habits by changing countries. I expect you'll either have to choose between the heavy drinking of your norm or sobriety.
How's your grasp of the language? You might be able to find meetings online, at the very least they can tell you where the sober hotspots are. I'd offer my services but I actually only Catalan, no Spanish.