Apple snails and coldwater tanks are a bad way to go in general. I would say a Viviparid is you best choice, they are excellent coldwater snails and traditionally kept iwth goldies in Asia. Only problem is they can't handle temperatures over 75F, 24C. They are also harder to keep, since the water has to be pristine (0 nitrite/ammonia and low nitrates). Other options for coldwater tanks:
- Malaysian trumpet snails, MTS (trial and error, some may do better than others)
- Planorbid ramshorns, "european ramshorns" usually. They are the small red/brown guys. Just have to be careful that they don't overpopulate.
- Lymnaeid snails if you can find them, all over Europe, but they need REALLY cold water
Things to avoid snail variety-wise in a coldwater tank: all apple snails. Don't go for Pomacea bridgesii, canaliculata, or Marisa cornaurietis (giant columbian ramshorn). They can overwinter at cooler temperatures but it has to be carefully done--I don't recommend it if you're going to plop them right into cool/cold water. Viviparids and others are better for that, with Vivs being the best bet probably.
EDIT: forgot to add, Vivs are usually sold as "Chinese/Japanese mystery snails" or "trapdoor snails" or "live bearing mystery snails".