Hmmm... what's your budget for this? What do you use your computer for? Do you play a lot of games or use any other demanding apps?
If you want to upgrade your Celeron, we can give you links to CPU's that will work with your mobo. If you want to actually know all this stuff, it's going to take a long time!

It's all very complicated and can get confusing quite fast, so I won't actually start typing anything unless you're sure you want to spend a week or two learning it all.
The highest speed Celeron is currently at 3.2GHz (released) with the 3.33GHz version coming soon. But neither of these ones will work with your mobo because they use the new LGA 775 socket. You have the slightly older Socket 478. For your mobo, I think you can go up to 2.4-2.8GHz, but I'd have to check out the web page for your mobo first. The fastest P4 you can use is most likely the Northwood B 3.06 version with Hyper-Threading enabled, but I don't know if that chipset supports HT (again, I'd have to look it up).