As someone who rides occasionally and mostly on the week-end, the last thing you want to have to bother about is your tires. Investing a little bit more in durable tires is a very good idea if you don't want to have your Saturday ride delayed or canceled due to a flat.
There are many options that are all viable options.
I personally ride Michelin Krylion Carbon tires and I'm more than pleased with the grip, the feel and the durability of those so far.
I rode Specialized Roubaix Armadillo Elite tires which are supposed to last forever for 1891km and they were done for so I was a bit disappointed. Bad luck or bad tires, it's hard to say.
I've read a lot of good about the Continental 4000 tires, haven't tried them though so I can't give you any help concerning those.
All in all, spending a bit more on tires is always a good idea if you want to get more durable tires. You can also get lighter or racier tires but be aware that those GENERALLY last less than training tires like the Michelin Krylion Carbon.