Waterside hotel given new name as multi-million pound refurb