What camera could i use to video at night?

[New-otec]

I am looking for a camera that could take day, dusk and night sky video.

I don't want to time lapse for just 5 mins of video - 

I'd like to to just put the video camera to record, on a tripod, and then go to bed.

Is this possible - ? 

Albeit with the right lens...(?) 

Which then makes me wonder.

What video camera, can hold a lens that is good for low light? 

Must be video. 

Can you help me, please?