Light Up Skyrim, according to its mod description, allows putting light sources anywhere:
Tired of that lightless alchemy room in breezehome, your dark dank basement in Proudspire.... No more! A warm lit welcoming home to come to...
This mod allows you to spawn a light source wherever you like.
Another (possibly more fun) alternative is the SM Drop Lit Torches mod:
This mod allows you to drop lit torches to the ground when you can't spare a hand to hold it.
You can combine this with a mod like Double Torch Radius or Torches for Realistic Lighting (but don't use Realistic Lighting as it will make interiors darker), to increase the light radius of torches.
Then, just drop lit torches all over your house (good thing all houses in Skyrim are fireproof).
Disclaimer: I haven't tried any of these mod setups. (I might, when I have the time later.) I prefer my in-game house a bit darker, and use Realistic Lighting to do so.
A post (Renovate your House with console) in the Skyrim Nexus forums has a detailed description of how to use console commands to add light sources and other items in your game. It includes form IDs of objects that you might want to put at your house.
(Thanks to kotekzot for posting this link.)
Quoting a part of the post here:
Every FormID (item/object ID) (The best decorating categories are on the right.)
Light FormIDs only
Basic Commands:
MarkForDelete = Delete Object (Open Console, while in console use mouse to click the item you want to delete, leave and return to area or Quicksave/load for the item to actually go away.)
Help X 0 = Replace X with query (ex. Help Bed 0.) to find everything named bed and get the objects ID.
Placeatme X = Replace X with Object ID (ex. Placeatme AF6AE.) Click a position while in console, will place the object there. (rarely works)
Player.placeatme X = Same as above except places object directly below you. Look straight ahead for object to spawn straight.
TWF = Wire frame to check clipping of objects.
TCL = Fly to allow you to place objects in air or on wall.
Getpos x,y,z = Gets the position of an object (ex. getpos z)
Setpos x,y,z # = Sets the position of an object. (ex. setpos z 250 ) good used with getpos to take floors z axis, then set your objects z axis to be the same.
Getangle x,y,z = Gets the angle of an object (ex. getangle z)
Setangle x,y,z # = Sets the angle of an object. (ex. setangle z 245 )
Rotate x,y,z # = Rotates the object manually. (ex. rotate z 245)
Setscale # = Sets size of object.