My mum used to have a static caravan on Riverside Holiday Park Morecambe, Lancaster road.
They sold it about 2 years ago due to ill health.
But it was a nice quiet site, nothing for children, it sits on the edge of the River Lune, theres an oldy world pub more or less on your doorstep.
The road does get flooded on a couple of occasions when its high tide think its about twice a year but I may be wrong.
I do miss going up for the odd weekend.
But do bare in mind there are a lot of rules and regs on a static site (my mum had to pay over £2,000 to come off! the site) They couldn't sell the caravan as new owners took over.So in the end they got nothing.
I seem to think the site rent was about 1,500/1,70
Depends what kind of site your looking for, just do your homework first as in buying ,selling again etc.