You can find plenty of ideas Here

Ice cold vodka in an ice cold shot glass is a joy. I like it in the winter for some reason. I keep a small glass bottle in the freezer marked ANTIFREEZE. It's kind of sweet, almost minty, a little more viscous so it gives an interesting mouth feel, and no harshness at all. I have drunk with Russians who said 1) ice cold 2) down the whole shot, no sipping. I prefer to sip as long as it stays cold. Those guys brought some Russian vodka with a Russian label, the stuff they don't export, and it was delish.

Wow the previous owners probably invested a lot of money into that wine cellar. I can see how it would be very difficult to handle if you don't drink wine. I actually love your idea for yarn storage. Just think how beautiful the colorful yarn would be neatly organized in there! That said, I think your options are to dismantle the room and turn it into something completely different, or somehow repurpose or leave it as-is, but empty. You can always store other beverages in there (fancy sparkling water, etc), but it's always going to look like a very high end wine cellar / collection.

We do use LED bulbs, I am just concerned about the wiring into electrical box in ceiling. Am I overthinking it? Our plugs in the cellar are damp rated.