We found this great Irish bar on out first night in town, excellent friendly staff. On the second night, before and after the game, as word had got around it was mobbed out with United supporters!
If you like hip hop, soul, R&B than this is the place for you (only on fridays!). Cool people, great music and dancing! The only disadvantage: it's pretty expensive.
Their Sangria is great, atmosphere is very good too and so is music and dancing... Well worth recommending.