Gym's don't become successful by just churning out body builders. They become successful by giving people the image that they want.
Any good gym will give you access to personal trainers, if you explain the body image you want to achieve they will help you in every way they can, through both setting you routines and helping you to create a diet plan to achieve your look.
Go and speak to your gym, they won't bite and they'll be happy to talk you through their processes and how they'll help you achieve your goals BEFORE making you pay.
One piece of advice you need to hold in mind is that this is a lifestyle choice, you don't achieve what you want through lack of effort. Most people fail at training because they don't commit themselves 100%. You need to push yourself and stick to it rigidly to achieve your goals.
Good luck with training
