Need recommendations for security cam 3-500 feet away

hwitten

Objective is to monitor/secure around a small shed that sits isolated at the edge of a lake. Not quite on the edge but rather 15 feet or so up the bank.
Power is available at the shed. Thought is that a motion activated camera watching the door will deter the honest intruder.
Hoping that an added siren, set off by camera motion with it's external relay output will add to the deterrence.
Motion will be recorded on internal SD card.
Basically trying to discourage vandalism while realizing the hard core will take camera and all anyways

My WiFi is about 3-500feet away, across the lake. My cell can reach from the location using my WiFi, but not reliably enough to assure 24/7 recording.

I'm thinking of using a Reolink WiFi camera for the job, perhaps increasing range using additional antenna?
Have not decided on model yet. Looking for best range, spotlight, local recording on SD card and hopefully a relay to activate (external) siren.

Hoping that extending range of a camera has been done before and that recommendations / suggestions are available. Adding a wireless bridge is not an option due to budget constraints. Sorry about the loose measurement