This extraordinary church was the vision of one man - William St Clair - and mystery seems to ooze out of its walls