You need it to be in a dimly lit area, without a lot of surrounding ambient light, but enough of a light source to make an imprint on the film. This can vary considerably, because some street lights are a great deal brighter than others. You may have to go through a few rolls of film before you get a good understanding of what works best. A nice first try might be a tree or mailbox or some other object on a local road which isn't very busy but has a couple street lights. What to do You need to get some slow-speed film.
Film speed is a measure of how quickly light imprints on the image.
My own preference is to use slide film, but that's just a personal preference. I've never tried night photography with print media, and I don't feel qualified to speak to the difference. The reason for using slow-speed film in night photography is because even slow speed film will capture bright light at night, and the shutter can be left open for longer without overexposing the image. You want the camera's lens to be set to be as open as possible. You also need to remove any special filters you generally use on the lens.