Glasgow's a really nice city though. It has one of the best record shops ever, Mono, and most people there are friendly. Also, if you want to score some smack then I understand that it's the place to be.
As for the accent, where are you from? If you can't understand a weegie then they probably can't understand you either. Oh, and don't openly support any football teams while in the city.
You should watch Sweet Sixteen, a film about a teenager living in Greenock, an area just outside of Glasgow. It's a really good film and everyone in it has thick acccents. There's an awful lot of swearing but that's just how people talk. The TV series Taggart is another good one if you want to hear Glaswegian accents. It'll also help give you a feel for the area. Maybe.