What tires work well there as I hear it is fairly smooth?
We ran Maxxis CrossMark 2.35 front and rear with good luck (and I like these tires on the tandem). I like those tires because the have good rolling resistance but still have good traction. I'm personally not a fan of Pythons or Smallblock 8s on the tandem (these are both poplular tires at Leadville.
Is a support crew needed? If not, what is needed to be self-supported.
Support not needed, nice to have though. You can have drop bags at every aid station if you wish. Having extra clothes in case of bad weather is nice. Having the specific nutrition that you are used to having is nice too. You can have both of these with or without a crew. Crew just makes it a little bit faster for your stops.
Can the support crew person drive to points on the course?
There are two primary points on the course (acually 4 b/c it is an out and back) where your crew can drive to. I don't think you need your crew at the first aid station (Pipeline outbound). Nice to have them at Twin Lakes outbound and inbound. Getting your crew back to Pipleline 2 in time gets to be a little challenging due to the size of the race and number of crew/spectators in the past few years. I can get you in touch with our first rate crew if you have logistical questions should you decide to go with a crew.
How far apart are the water stops? And what food will be provided?
I'll dig up my gps or race guide to give more specifics. The longest you would have timewise is between Twin Lakes and the top of Columbine which should be just over 2 hours.
How much water did you carry and how did it work for you?
We use camelbaks. maybe half full? Wife used liquid nutrition in a water bottle along with water in the camelbak. I prefer the reverse - water in the water bottle and nutrition in the camelbak. I find that I don't reach down for the water bottle as frequently as I should, but the camelbak is more convenient.
I can discuss in as much detail as you wish either on the forum or directly via email - feel free to PM me and we can discuss further. We are not the top finishers, but I completed Leadville once by myself back in 2003 and then on tandem in 2009 and 2010 and am always up for discussing .
Good luck and happy training!!