The most seductive interiors are shaped through specially commissioned pieces, where collaboration, ambition, skill and a willingness to take risks