There is no night time show at CSR, but it is absolutely beautiful at night!! I would say the resort is more stunning all lit up at night than it is during the day.
From certain parts of the resort you can see the high fireworks from EPCOT and MK. Reports are that the new Star Wars show at DHS has great views from CSR, but I haven't seen it for myself yet.