Apple will keep upgrading the OS for awhile, likely to around 10.5.10-11
But you will want to upgrade to 10.6.x as soon as Apple begins releasing apps that require it.
Which likely will happen with iLife, iWork, pro apps, etc. application released after 10.6 hits the market.
Apple tends to make most of their newest app versions require the current OS.