From prosecco painting to murder-mystery nights, pubs are hosting creative events to engage communities and tackle rising costs and changing consumer habits.