Rural retreats no longer mean dodgy plumbing and floral wallpaper. From futuristic cubes to designer flats, the modern holiday let is now your chance to live in an architectural masterpiece – even if it is only for a week