Leviton makes a Single Pole double throw switch commonly used for shutters. I have seen Maintained, and Momentary. I think for this it needs to be a Double Pole/ Double throw.
Hot will be the common on both poles then 1 light on 1 side(night light) the other half of the switch will have your bright light on both switched positions on 1 half of the switch.
This switch needs to be a "Maintained"(Not momentary). will see if I can locate correct switch.
I'm Back, here is the Double Pole/ Double Throw switch:
Leviton White DPDT Center-OFF COMMERCIAL Decora Rocker Switch Maintained Contact 5686-2W
You can use the Single Pole/Double Throw Mantained switch if you want to use one light or the other light, and Off.
The DPDT allows Both on for bright and only the dim one at night.