The Collaroy Hotel in Sydney’s Northern Beaches has reopened its doors after a Merivale makeover