Harrogate and District NHS Foundation Trust must “be ambitious for the future”, its boss has said, as it aims to transform services and improve care.