I've done a lot of night launches. My favorite effect is to put a dozen glow sticks in a 3" rocket, each with their own small estes chutes, and motor it for about 1000 feet. Load the glow sticks between your chute and the nose cone, so they come out first.
I've also made clear rockets out of cheap plastic shipping tubes and then filled them with lots of little lights. We've also attached the long skinny glow sticks (like for a necklace) lengthwise on the outside of the airframe, just using duct tape. There are dozens of small battery powered stick on lights you can get from Amazon. Just make sure you use some CA glue or epoxy, otherwise they'll rip off.
There are no bonus points for altitude at a night launch, so keep it low, so you don't lose it.