This is the bottle I used most recently and it's certainly much less leaky than any others I've had. It's not cheap, but has an extra hide underneath and multiple ways of attaching it or using it as freestanding.
UEETEK 2 in 1 Small Pet Hideaway and Water Bottle - Plastic Base Cabin Habitat for Dwarf Hamster, Red: Amazon.co.uk: Pet Supplies