Yes, Deep Creek Lake offers outstanding fireworks and you can view them best from the northern end of the lake since they shoot them off at the tubing park at Wisp Resort. Here is a link to shots I took a few years ago:
http://4wheelsphotography.zenfolio.com/p56043758
Hope you enjoy them!
Marcia
4 Wheels Photography