The multi-million pound Slaley Hall hotel and golf complex was officially opened with a party for 600 guests and a 25-minute fireworks display.