We went to a couple of places both on what I assumed was the high street. I dont doubt many northern towns are just as expensive I have visited many, however I still find the smaller Northern towns still suprisingly cheap when it comes to booze.
Last season when I went up, we were paying £2.85 a pint in some places. I remember my mate handed over £30 for 5 pints and got change back from a twenty.
Just head to the North Laine area as mentioned, you wont miss a decent pub or two around there.
I would always suggest the eagle to people. if you fancy watching soccer saturday and necking a few pints you will be limited to pubs up closer to the station though. Just work your way around you...