umm... hi.
i would say that yes, you should apologise.
he was obviously trying to take care of you by telling you not to drink
and if he's a friend i'm sure he would appreciate an apology.