The whole system isn’t cheap and you do need dedicated water bottles, which aren’t cross-compatible, but I think the Fidlock Twist system is fantastic.
£22.99
Score
Fidlock
Fidlock Twist Bottle and Bike Base review
Fidlock is a bottle and cage with a mechanical and magnetic attachment, that's available in 450, 590 and 600ml – the smallest fits into a tiny space.
£29.99
Score