The Blue Boy (1994)

Marie Bonnar (Dame Emma Thompson) is an insecure housewife whose husband, Joe (Adrian Dunbar), is having an affair. The two of them take a vacation 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.