If you are working from home then the best place to live is closest to where you sail most so you can get on the water before the wind dies.
North of the river is a bit limited for access- Pelican Pt is pretty much the only place to sail there. Gets really crowded in summer and has way less options for wind directions because its in a small bay. Its great in an easterly and seabreeze. Also the property prices any where near Peli Pt are astronomical.
South of the river is great for access. There are plenty of places to access the river in all wind directions. Melville Beach Parade (with trees for shade and nice grass to rig on) for anything from southerly through west to North, Pt Walter is good for anything but S through SE. I moved to Melville 18 months ago and its great. A few minutes to the river sailing spots, maybe 12-15 minutes to the coast. No state housing here

Surrounded by families with kids. Depends on your budget of course... Willagee is directly south and quite a bit cheaper, but it comes with state housing. The suburbs closer to the river get more expensive.