Any cafe with a view?

Planning to go celebrate last day of the year in the afternoon. Please suggest a few cafes and pubs with a scenic view which serves alochol.