I suggest that you start by looking at some Youtube videos on 3-point lighting effects.
Most pro light kits have come down in price, but all seem to be best suited for studio work, as opposed to shooting in a house. You’ll get a minimum of three in the 1000W-500W range. You’re biggest problem will be trying to dial down in most situations with dimmers and scrim. If you get a pro kit, and set up even a single 500 watt halogen, the room will as blown up bright as a hospital operating theatre.
Lighting is an art, and a skilled lighting tech will create magic.
But it is also, on the one hand, pretty easy. A minimum of effort will drastically improve your shots.
If you are planning to shoot mainly indoors, consider just getting a couple of directional office style, desk lights, and a couple of inline electric dimmers, and maybe a few sheets of ten-dollar gel filters to safety pin over the lights, from someplace like Vistek. Even with three 40 watt bulbs, you'll be scrambling to find ways to tone down two of them if you're shooting in a living room. Small light stands are available from China for super-cheap if you can wait a few weeks for delivery.
Don’t throw money at the project. It’s more about tinkering and experimenting. And creatively jury-rigging solutions to position lights in odd places, out of your shot line.
For outdoors, wait till the so-called “magic hour”, the hour just after dawn and before sunset, when the rays of the sun are coming in almost parallel to the ground, and give both nice shadows, and a warm glow to everything.