Sync noxfile with templates and add deps_from_source session

Follow-up with https://github.com/googleapis/python-bigquery-magics/pull/104#issuecomment-2722302855

Let's create a separate session for `deps_from_source`, similar to core_deps_from_source here: https://github.com/googleapis/google-cloud-python/blob/3609c907cf4c03bf08418de150c84c32da9dae1e/packages/grafeas/noxfile.py#L478-L537

Also, this list of pre-release packages should be updated as well as this is the standard list from synthtool templates

```
prerel_deps = [
"protobuf",
# dependency of grpc
"six",
"grpc-google-iam-v1",
"googleapis-common-protos",
"grpcio",
"grpcio-status",
"google-api-core",
"google-auth",
"proto-plus",
"google-cloud-testutils",
# dependencies of google-cloud-testutils"
"click",
]
```