Scotland's design story set to be told throughout waterfront museum under plans for 'more dynamic' attraction.