Nice to see a sound design-related question on the forum for a change.
As you know, every part of the world has a different "daytime" and "nighttime" vibe. Some locations have insects during the day (as @Danny James noted) and virtually silent nights, while others could be the opposite. Distinguishing between rural, suburban and urban will also cue what sounds may be appropriate.
But the interesting part of your question, to me, is how can you "heighten the tension" in the scene. That gets me thinking less about the accuracies of your chosen sounds and more about the emotional storytelling cues. Things like owls and dogs may root your scene in too much realism, taking away from tension, for example.
Perhaps try sounds that would be native to your location but slightly twisted; just odd enough to give the audience a sense of unease, that something's not right. Maybe play your cicadas backwards! Maybe pitch your owl down half an octave and put it a mile away, using EQ and reverb! Maybe your dog barks could be whimpers and whines!
Experiment! There is no wrong answer.