Mine runs happily at 850 MHz on stock voltage - so I haven't increased yet, as there's no need. Think I bumped it up one notch on the scale to run it at 900 MHz, but to be honest, I can't recall. I only tested it briefly at that speed, then reduced it for everyday use (for now).
PSU Wattage is often over specc'ed I think, so it depends on the rest of your system really.
The GPU itself isn't going to use crazy amounts of power. If you check the card spec's you'll see it's rated for 160 Watts at normal speeds - so I'd increase roughly in proportion to your overclock then add a little head room.
In highly doubt you'd use more than 250 Watts, even with the card cranked to 900 MHz, but I could be wrong.
GTX 460 Specs:
http://www.gpureview.com/GeForce-GTX-460-1GB-card-632.html
The most accurate way of measuring power draw is to put a meter on your wall socket and measure the difference at the wall plug, before and after installing your video card. That will tell you the actual "real world" difference, rather than some "in theory" measurement.
Personally I've been using a 750 Watt PSU for the last few years and it suits me perfectly. It's got enough power to run 2 normal level GPUs in SLi or Crossfire (by "normal" I mean nothing too crazy - like twin GPU cards etc), about 4 HDDs, an SSD, a DVD combo drive, sound card etc - with a bit of power up its sleeve - but being honest, I think I could probably get by on about a 550 Watt supply, assuming it was decent quality.
So I think - some where around 650 to 750 Watts for a relatively normal system, that might get a second video card added to it down the track etc - depending on the exact components.
Brands - depends on what you can get in your part of the world - brands like ThermalTake (the toughpower series), Corsair, EnerMax, EverCool, CoolerMaster & Antec all make good PSUs. Go for a nicely made modular that gets good reviews. You want something stable, that doesn't drop volts too much, when the loads increase on the various power rails. PSUs are one area where it's better to spend an extra $50 for better quality parts, as you want a reliable system.
You might get some value out of this page too - list of 460 GPUs and their respective overclocks (don't take it as gospel, use it purely as a rough guide - all cards are unique and your exact results may vary etc).
http://www.gpureview.com/gpureviews-gtx-460-overclocking-roundup-article-858.html