Paul Morrison’s £79,000 artwork will boost tourism, North Yorkshire Council says.