For that type of photography, you need a camera with a bright lens and an ISO setting of 3200.

Something like the Canon 350D Rebel with a 50mm f1.8 lens (about $850).

There are a few small cameras that can perform better in low light than you Nikon S1. But you will still need to set the camera on a tripod or on a solid support, because the shutter speed will be slow.

Here is a sample shot from the Fujifilm F11 (not available in USA):

http://forums.dpreview.com/forums/read.asp?forum=1012&message=16444239

Settings were f2.8, ISO 800, shutter speed 1/10th of a second. The camera was setting on a table.
Note....at the end of the bar, the blur of a waiter that was walking when the shutter snapped.

...
..
.