Everyone's experience of university will be different. I wouldn't say mine were the best years of my life. In fact the year or two preceeding university (and eprhaps a couple of years of university, or at least withdrawn from university, were among my worst). However, I am not typical as I did experience some significant personal and health difficulties from the age of 16 until well into my 20s and this obviously affected things. Even so, I do look back at my (long and disrupted) time at university and realise that it was a positive experience.
I'm not into clubbing myself, nor do I smoke or (usually) drink much. However, I did develop my interest in the theatre more and discover new academic interests. When I returned to university, after spending some time withdrawn, those were some of the most positive times I've had so far in my life.
My university years did provide me with the opportunity to learn more about myself and overcome signficaint challenges. I still feel a little unsatisfied in that there were things I wanted to do but couldn't. I would hope, but don't expect, that the next few years will be an improvement as they will allow me time to travel and settle into a career I'm passionate about.
My advice would be to not get too obssessed with whether the next few years should be the best in your life. Just go there and try and make the most of it. You may come back in three or four years time and say "hey those were the best years of my life (so far)", as many do, or you might not but providing you tried to make the most out of your time at university you should certainly have some positive experiences that you'll keep for life.