Sir Rod Stewart was in high spirits during a wild night out celebrating his whisky brand's birthday in a swish Las Vegas club on Saturday