This bastion of modern design and artistic expression has just opened to the public as a National Trust museum. The epitome of panache is now captured under glass and water by Brad Moroni.