The historic former shipyard site is a thriving waterside hotspot of shops, bars, restaurants and homes