New name, Bristol Dockyards, and museum revamp aimed at becoming more rooted in community, says chief executive