"Would you like any bread?/Can I have any water, please?" don't sound right. "Would you like any of these? - Can I have any of those chocolates?" would be okay. But then "any" is used in a different context.
When you offer somebody bread and ask, Would you like some bread? they can always say, No, thank you. Conversely, if somebody asks you for a glass of water they'll say, Can I have some water, please. You can't use "any" in this context.
Unless there is a choice. "Would you like to taste any of my crackers? I'm warning you, they're all hot. Just try one." "No, thank you, I think I'd rather not try any of your special crackers."
You can ask "Would you like some this or that", expecting an affirmative answer. When You use "any" there should be a choice.
Would you like some cake?
Would you prefer any piece of this cake, (perhaps the one with the cherry on top)?
Still, I'd advise you to stick to your some/any rules.