Any home-repair store should offer fans with ceiling lights, and if there is none within the immediate area, it's possible to purchase fans online from stores like Home Depot or Rona.
Without knowing some more facts, there could be several different answers to explain why a ceiling fan's lights "go out": someone has turned them off at the switch for the lights on the fan unit; the...