The best word to fill in the blank and logically connect the two sentences is:
B However,
The sentence would read: "The little puppy had been begging to go outside for over two hours. However, once the puppy had been outside in the 90 degree heat, it wanted to go back inside immediately."
This indicates a contrast between the puppy's desire to go outside and its immediate wish to return inside after experiencing the heat.