The Blue Boy(1994)

Marie is an insecure housewife whose husband, Joe, is having an affair. The two of them take a holiday to rural Scotland, but by sheer bad luck, end up at the hotel Joe uses for his "getaways." There, Marie is told the story of a young boy who drowned in a nearby lake long ago, and finds herself becoming more and more obsessed with his ghost.