Consider buying a few pieces of equipment for home so you can avoid busy times at the gym.
If you're nervous, and you have some flexibility, time your first visit or two to a time when fewer people are around. Familiarity with your surroundings make it less intimidating. And if all else fails, take a friend! Support in numbers, and you have a built in cheering section.