Well, a lot of that depends on the aquarium, and on the house. Most houses are going to be using incandescent or NO fluorescent lighting, and a lot of simple aquariums will be, too. Some houses, my own included, use the
PC fluorescent lighting, just because it is more efficient and the bulbs last longer. The only time you're going to be seeing drastic differences in lighting is when you start looking at planted tanks. Those need a lot of wattage so that the plants can grow, and so they use high wattage
VHO or
PC or even ODNO fluorescent lighting, which you probably won't see in your average household.
Largely, the main difference you will see between aquarium lighting and household lighting is the colour temperature (measured in Kelvin degrees) of the light. Sunlight will be 5,000K+ and this is the range you see for lights in planted aquariums. In a household, though, thoe lights would look unnaturally blue, and so household lights will be in the range of 2500-5000K, which is a lot gentler (not to mention more flattering) on the eyes.
I hope that's helped.