I actually noticed that if you go to 'proper' gym (meaning, not the kind where peeps just go to show off their new spandex thongs), people are actually surprisingly nice. I went to check one out recently that I'd never been to before, and it was full of the body-building type of guys (and girls). I just wanted to turn around and leave, but I had an appointment for a trial workout, so I thought 'what the hell, I'm used to the stupid looks' and went for it.
Turned out that all those bulky muscle people are pretty cool. Yeah, I felt out of place, and some people looked over, but there was no giggling or anything. In fact, once the trainer had showed me all the stuff and went to get a drink, one of the guys came over when he saw me struggling with something, and pointed out how I could do it better. He asked what I was planning on doing, training wise and I told him about the weight loss and needing to get in shape and all of that. Turned out he'd been overweight for most of his life himself, and had only lost weight and started working out a couple of years ago.
Later on, when the trainer helped me to find the right weights and stuff, a woman (again, the bodybuilder type, really fit and everything) who was next to me on the same machine looked over and said 'Wow, when I started I couldn't even do half of that, you're doing well'. Not much really, but it made me feel good.
What I am trying to say is, don't let anything or anybody put you off doing your workout. As Trusylver said, most people in the gym are concentrating on what they are doing, and don't care about the rest. And if they do, they are most likely to help and give you some advice and encouragement more than anything else. Don't forget, none of the peeps in the gym were born perfect, they all had to work hard for whatever body they have now, and those who are serious about it remember how much hard work it is to get there and stay there.