A "revolutionary" new sports entertainment venue is set to launch in Ayrshire next month, promising to “completely transform” the social scene in the area.