If a room is very dark, or an upstairs room is lacking natural sunlight, a skylight can be the way to go.
Below are videos on how to install 2 different types of skylights, and information on how to repair a leaky skylight.
Installation
Part 1
Part 2