At night is used when we talk about every night.
- At night it goes dark.
(This means that every night it goes dark.)
- At night we can see ghosts.
In the night talks about a specific night.
- In the night I felt ill.
(This means that on a specific night I felt ill.)
- Did you hear that noise in the night?