Tour de France fans will learn there's "more to Yorkshire than Last of the Summer Wine" in an arts festival showcasing visual arts, dance, music and theatre