It's honestly hard, and the first year or two won't be great. Boardgames and cafes are boring as fuck compared to getting drunk. Sure, rafting and cycling and other examples might fill up a Sunday afternoon, but they don't work for Friday night.
Over time you adjust. I've made a few friends that don't drink. I have others that I can go out with and they don't mind me not drinking.
At some point you realize that you won't be having as much fun as getting drunk. But your life will be better in other aspects, and that will make it worth it.