Homes with 'wow factor' to be built on former school site