Sunnytours is a pleasant, almost idyllic fortress. A small aboveground building housing the trade depot and llama pasture. A decently sized production area in the soil layer, and a modest living and dining section in deeper stone. With a population of 29, Sunnytours supports itself with a thriving stone mug export business.
There is just one thing to keep in mind before traveling to Sunnytours. You had best acquire a taste for dwarven wine, because that is the only thing you will ever drink there.
Sunnytours is an experimental fortress I built to test the claim that dwarves will refuse to drink if you don't give then variety of booze, and will die of thirst if no water is available. It's a simple, small fortress, with a low population cap. Invaders is turned off so I don't need to worry about defending it. The only booze that is produced in Sunnytours is dwarven wine. Initially I did this by only growing plump helmets, but later I realized that I could safely grow the other plants so long as I only permitted brewing of plump helmets in the kitchen menu.
Sunnytours does not have a well. There are murky pools on the map, but the front door of Sunnytours is sealed with a raising drawbridge that is kept closed except to allow traders and immigrants in and out. No booze is purchased from any of the traders, so the only thing available to drink is dwarven wine. There's plenty of it, I queue up some more to be brewed whenever I fall below 500 units, but nothing else at all to drink.
So far, I've had the fortress running for about two years. In that time I have had two deaths, both the results of failed strange moods. No deaths of otherwise healthy dwarves due to thirst have occurred.
On checking the thoughts of various dwarves, I see that nearly all of them have the 'tired of drinking the same old booze lately' thought. They're all still ecstatic due to high-quality rooms and masterwork meals and such, so it's not a problem. The only dwarves I can find who don't have the 'tired of drinking the same old booze lately' thought are those who 'prefer to consume dwarven wine'. Those dwarves have thoughts of 'had a wonderful drink', 'had a fine drink', 'had a pretty decent drink', 'had a truly decadent drink'. How nice they thought the drink was seems to be randomly distributed. Either there are hidden quality levels to drinks after all, or how much a dwarf enjoys a drink is semi-random.
I have not noticed any increase in the number of thirsty dwarves. When a dwarf does become thirsty, he does what you'd expect - goes straight to the dwarven wine stockpile and gets a drink, regardless of whether he is tired of the same old booze or not.
When I open the front gate to let traders in, I watch carefully to see what the dwarves do. I have yet to see a crowd of thirsty dwarves charge out to drink pond water. I have on occasion see a dwarf with the 'give water' go out, fill a bucket with water, and then take it to a thirsty dwarf. This seems to be a known behavior where dwarves who get thirsty while working on a job trigger another dwarf to bring them water as if they were injured in bed. I don't think this is related to dwarves getting sick of the same old booze as I've seen it occur in fortress where every type of booze is available.
During the times the front door is open, I have watched carefully and have not seen a single dwarf go out to drink water.
I'm going to keep this fortress running a few years more, but I don't expect these results to change.
tl;dr:
1. Dwarves never prefer water or dying of thirst to booze even if they've been drinking the same old booze for years. They get a bad thought, but go right on drinking booze.
2. Dwarves who like a type of booze never get tired of drinking it.
3. Dwarves get a good thought when they drink a booze they like. How good this thought is varies, being either random or based on hidden quality levels.