Like other people have said, the options available to you are going to depend on what specific P&S you have. Some have no manual control at all, others support manual ISO settings only. Nicer ones will allow you to control the shutter speed, exposure and aperture, but yours may not. What camera is it? (ed: reading comprehension fail. Not familiar with the J10, I'll have to look into it)
Tripods and monopods are probably going to be largely ineffective if you want to take clear, detailed pictures of the fish themselves; there's simply no way that you're going to get them to hold still for long enough under normal aquarium lighting (unless they're an extremely sedentary species to begin with) for the camera to expose the shot correctly. They'll work fine for taking whole-tank shots though.
If you really want to get pictures of the fish themselves, the solution is probably ultimately going to be more light. Even if your P&S camera allows you to bump the shutter speed up high enough to eliminate motion blur from the fish, there are going to be other consequences from doing so (very poor depth of field, excessive sensor noise and/or a severely underexposed image) that are probably going to render the image useless.
I'd recommend getting one or more clamp-on worklights (
these things), which should be available at any hardware store, and a corresponding number of GE's 26w 6500k "Daylight" compact fluorescent bulbs (
these). I'd start with about 1 per 10 gallons for normal-height tanks and go from there. Deeper tanks like 20XTs and 55s will probably need more than that, but start there.
There are cheaper ways to go about getting more light into your tank, but they're unlikely to work as well. There are some "200w equivalent" CFL bulbs out there that would be brighter, and there are also relatively cheap 500w halogen worklights which work great (although they get hot enough to melt things if you're not careful), but with a normal P&S camera, neither is a practical option for you. Most CFL and halogen bulbs give off a very yellow light; about 3000-4000k; if you're using a camera with RAW shooting and full manual control you can correct for this in post processing in a program like lightroom; that's what I do with my shots. But when you're using a P&S that probably doesn't offer full manual control, probably only shoots in jpg, and when you (I assume) don't have a program like lightroom or photoshop on hand to fix it, what you end up with is a very yellow-tinted picture, which doesn't look very good at all.
So yeah. Cliff's Notes: Try the clip-on lights with 6500k CFLs.