Despite this garden's northern location, an enchanting collection of cacti, succulents, and tropicals call this landscape home