Your motherboard is capable of 2x operation. I don't know if your mobo will take the 1.4 celeron, but if it can, great! You should be able to find a PIII 800 - to 1000 if it doesn't. I would also upgrade the ram, too.
You aren't really suffering with th HDD being limited to ATA-33, as the sustained throughput for any IDE HDD isn't that great anyway.
Mind you, this stuff isn't really worth doing unless you can get the parts cheap or already have them lying around.
As for the video card, you might want to stay away from the nVidia lineup since they are very power demanding. The power supply you have installed won't be the issue, either. I have owned systems like this that would not work with any GeForce 4 cards because the AGP slot wouldn't provide enough power to the card. It did work with the GeForce 2 line. I eventually settled with the Radeon 7500, although the Radeon 8500 would have been a better choice.
So, if you really want this system to limp through the next year, you could possibly do what I have mentioned. Just don't expect to play Unreal 2 at any good speed. With mine, a PIII 1ghz, 256MB PC100, Radeon 7500/GeForce 2 Ti, Maxtor 7200 RPM 8mb cache 80 gb HDD, I easily played any Quake 3 based game, all the Half-Life based games, Medal of Honor; basically anything that wasn't super advanced. It had difficulties playing Unreal 2.
The Geforce 2 Ti and the Radeon 7500 scored very close to each other in 3DMark 2001 and performed similarly in games. Like I said, a Radeon 8500 (FYI - The Radeon 9100 is an 8500 LE in disguise) would have been a better choice, as it didn't suck power like the GeForce 4.
EDIT:
Links would be nice, no?
www.powerleap.com - They have a large lineup of Slot-1 adapters and software to help you find what's right for you. The software is helpful.
http://www.newegg.com/ - A good source of video cards and ram. Good prices.
http://www.starsurplus.com/ - The only place I have found that has a decent supply of Slot-1 processors that go up to 1GHz. Pricey!