The Globe usually gets the most Newcastle fans, but SmallBar and AJ Hudson's are good too. Not sure on a Scottish bar, there's probably 100 Irish pubs around, but I'm sure if you look online you'll find some. FYI, all these things are on the northside, so it'll be a bit of a trek for you from Hyde Park.