You need two things.

A digital camera with manual controls and a tripod.

Low light photography will almost always require that you use slow shutter speeds. You should not hand hold a camera when shooting at shutter speeds slower than 1/60th of a second.

Manual controls such as "Shutter priority" and "aperture priority" give you better control of exposure settings.

For under $300 I would start by looking at the Canon A610.

...
..
.