A luxurious Cheshire mansion, featuring an indoor pool and cinema, has hit the market with a £6.5 million price tag.