So a Tdi is likely to return 24-28mpg real world. They can do better, but you'd really need to try. A V8 is going to use more fuel, more like 15-18mpg and up to maybe 20mpg on a run.
Don't know how many weekend miles you'll do, but making a few assumptions 10-15 miles a day would seem to be...