No. You are not going to see an appreciable improvement. What you are talking about is a willamette p4. It is a horrible, horrible performer. An Athon XP 1.53Ghz can easily match a 2.0willamette even though its PR is only 1800. The PR is more accurate for northwoods.
I would guess that your new P4 will be around 30% slower than your Athlon in SSE2 applications and closer to half the speed in some important ones and especially scientific apps like DC. Don't even bother. That board will take a northwood though. If you can get one, do that.
P.S. The Athlon uses Exclusive cache meaning that it stores different information in L1 and L2. This means that it has 384K of total cache. The willamette, however, replicates the same data in both the L1 and L2 cache so you only get 256K total. The Athlon has half again as much cache (150%)