'What other event lets you have a nose around people's houses' – Arts festival hailed a success