I need to find this horror movie

This sort of sound like House of 1000 corpses with Sid Haig playing the clown. This was pretty gorey if I remember....

The movie you are looking for is probably House on Haunted Hill (1999). It is a remake of the 1959 film of the same name. The movie stars Geoffrey Rush as Frederick Loren, a wealthy man who invites a group of people to his haunted house for a party. The guests are unaware that Loren is planning to kill them all.

The movie has a similar plot to the one you described. The married couple in the movie are played by Famke Janssen and Taye Diggs. They drive by the haunted house and decide to go inside. They soon realize that they are in danger and try to escape. However, they are trapped by Loren and his family of psychos. The movie ends with a twist that reveals that Loren is not the only one who is planning to kill the guests.

The movie was a box office success and received mixed reviews from critics. Some critics praised the movie's scares and atmosphere, while others criticized the film's unoriginality.

There is a pretty good chance this isn't it, but there was an anthology film titled Necronomicon: Book of the Dead that came out in 1993.  https://www.imdb.com/title/tt0107664 .  One of the stories was titled "Whispers" and it kind of felt like what you described.  Try looking at this on a YouTube video at https://www.youtube.com/watch?v=ymcdWYXWSA0&t=500s and see if this is it.